UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rk8e59ihNRYhI1bLpcYvPJ4gwIWeKKWDaJTheTsUEJY='
WHERE
key_id = '024813e8f9300bdea7873849da50be2ba6751aa3958374a25cd88da5be89673d'
AND (
token = 'rk8e59ihNRYhI1bLpcYvPJ4gwIWeKKWDaJTheTsUEJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)