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