UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3UNE8hO/IVgvLYC83TuV1naH2gvSW+Fss0LmWZRQE3U='
WHERE
key_id = 'ae45fd13b0589ba669bd9fe700facdbd9c40289c4511ed5b0c5165241170e5da'
AND (
token = '3UNE8hO/IVgvLYC83TuV1naH2gvSW+Fss0LmWZRQE3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)