UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9PdGc7XeY2z6qhxEBEd1eG27u5EwSTwvkVWdBHxjSgc='
WHERE
key_id = '39927c7fec3751b2595fea18e0e3de9c86376db7b721d1118aee0537d05b3011'
AND (
token = '9PdGc7XeY2z6qhxEBEd1eG27u5EwSTwvkVWdBHxjSgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)