UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8EszP7XX7GS0VOUo7C73j6bfRuHHTuHBY/JS4umpeiA='
WHERE
key_id = 'dd26a0735bfc05ddbb0f688f22aa2b4b90039a96bf9b774db959415f83f45afc'
AND (
token = '8EszP7XX7GS0VOUo7C73j6bfRuHHTuHBY/JS4umpeiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)