UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z/bL+nBTbVpYlSQSydLv2QvxtmsqI2UPyLzTu0sa0eU='
WHERE
key_id = 'b508a6ae59b148f33ef41be9437da60cec1df214a0afce8da3a08ff5fd093c18'
AND (
token = 'z/bL+nBTbVpYlSQSydLv2QvxtmsqI2UPyLzTu0sa0eU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)