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