UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0yK3p54o2Gj76Ql6qQwudlmhlnLGkscGBsJP0rhD5g4='
WHERE
key_id = 'c187cf23a71a5abb2e48ddb79f6752562fcb66dc184aaf606d0b3f884982dc5f'
AND (
token = '0yK3p54o2Gj76Ql6qQwudlmhlnLGkscGBsJP0rhD5g4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)