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