UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CdPDZe7myKgtnM/hqikcC80jfMz/j72mEo/cgIrVxjc='
WHERE
key_id = '27c79996da676617616aa087cdd8a0bd42d88c1456221d2aa7ec03de46172cbe'
AND (
token = 'CdPDZe7myKgtnM/hqikcC80jfMz/j72mEo/cgIrVxjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)