UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GHYaW9Yw1mmnRsBRNddTV5EhCac2Zxu1n5juJyVboUo='
WHERE
key_id = 'cfe073e1f92aaa41a5f5d7578edd3fb7927696c3b896a8c77b6d34409b3af77e'
AND (
token = 'GHYaW9Yw1mmnRsBRNddTV5EhCac2Zxu1n5juJyVboUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)