UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9o46Ju3cGgFh5Oe2K2KGHFEbuZSwH10pXbgv/4j/J5M='
WHERE
key_id = '27664fd2faf0543c92ee83e5d59673cceac83925f631668fa9c0eecbaccce2d2'
AND (
token = '9o46Ju3cGgFh5Oe2K2KGHFEbuZSwH10pXbgv/4j/J5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)