UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRbPSdBl6i4etpMUkubZuo65v20D3WE+229HoPTAT40='
WHERE
key_id = 'bd2a5df6e5c7336f766930aa02749b0625f11fb64f504adc4211dfb07ae3fa75'
AND (
token = 'NRbPSdBl6i4etpMUkubZuo65v20D3WE+229HoPTAT40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)