UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T4gAURmLhHJ/0kKbukqVgF11D6sf7gs4KTO9PK7RfbY='
WHERE
key_id = 'c419380c081a77d66c8afe9cc3f6618165d938d05dc843f166be65908b86d3a0'
AND (
token = 'T4gAURmLhHJ/0kKbukqVgF11D6sf7gs4KTO9PK7RfbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)