UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9mdoYPyiTsJ7HprDp5pkbXfKvWev/1sYFl23otBjmc='
WHERE
key_id = '9feb7268bf64dab2d13f5c35cfd84563ef9c7461fa7fc8ad6eaec3b437340ee5'
AND (
token = 'k9mdoYPyiTsJ7HprDp5pkbXfKvWev/1sYFl23otBjmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)