UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zB4mPe95wPD+bDlhDkj6kJOMv+lwibqNnI+Ex4H5eGk='
WHERE
key_id = 'f298f0557b57cc554a063167becc13755f5f085d74cd460e35540ec7900b1214'
AND (
token = 'zB4mPe95wPD+bDlhDkj6kJOMv+lwibqNnI+Ex4H5eGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)