UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yl8JHaWcofPjUPqQiGf2U3VLtcKgCjUzLXt3Y4LWQ+A='
WHERE
key_id = '06b7d3117c8e6f12b7163902b559e84491c540f6703d46ae3ddbde4bae53cc8c'
AND (
token = 'yl8JHaWcofPjUPqQiGf2U3VLtcKgCjUzLXt3Y4LWQ+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)