UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5QS3DZFyh4TkRh/zIzfRXXM9klRK6eBShpZFIVBb9o='
WHERE
key_id = 'e338c3216ced33f8fa978de94f50ef0edbce7a9cbe5b048194f55e92474ec337'
AND (
token = 'B5QS3DZFyh4TkRh/zIzfRXXM9klRK6eBShpZFIVBb9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)