UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4nA+19l8Qex3opB0+xuTpsN3+MgecUZxWytiZj3YnA='
WHERE
key_id = '00467bc9f93177e79a1a58728a81a6a4c84528ed3ec9e44b655dfefd64731170'
AND (
token = 'C4nA+19l8Qex3opB0+xuTpsN3+MgecUZxWytiZj3YnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)