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