UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/qguxZB5QmGMrFCKhhIQ9Pe5p0OklWj7DEX+5i5l3kI='
WHERE
key_id = 'c3c13aa97e8283838604538eb0cfee71ce2a09e0f611dcf058219c943f11a1fd'
AND (
token = '/qguxZB5QmGMrFCKhhIQ9Pe5p0OklWj7DEX+5i5l3kI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)