UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BqlA84rS88aUXk/IngAjqW/xm4ja4rqkfN2DKDDaWtk='
WHERE
key_id = 'd2ce63d0b584b616d0961a41e94198ea9c050906433dfb16bd27ba033bb8383a'
AND (
token = 'BqlA84rS88aUXk/IngAjqW/xm4ja4rqkfN2DKDDaWtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)