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