UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKq0gqzIxeVFIe78s6A3rfCeIVO3oKKD8P7Zs27g/Fc='
WHERE
key_id = '8e1b135d447653bc6f6eb48a6aaefca7ddf07e2b2cb2a855957a63cb82addba0'
AND (
token = 'yKq0gqzIxeVFIe78s6A3rfCeIVO3oKKD8P7Zs27g/Fc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)