UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NOzH7TQHsETAJQBjNIUzTN86HLZHmcw5yRs7kBC7PlU='
WHERE
key_id = 'd27285751f70ac5373eaaf4361153cff7b01ac224e0a7c4d052343fdc737185f'
AND (
token = 'NOzH7TQHsETAJQBjNIUzTN86HLZHmcw5yRs7kBC7PlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)