UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4Y1ywlS9ZiLqWoWM2PyTxiJwRo+iBrSWw1XRg1+ALk='
WHERE
key_id = 'd6493696dbfc5d3eaf1df4df35fa7288ad0c0e1a8f1894350215b00e7ea492b9'
AND (
token = 'a4Y1ywlS9ZiLqWoWM2PyTxiJwRo+iBrSWw1XRg1+ALk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)