UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RVwT6liaH5Cfy1v3Cr9hiy49ybpPznNhYLTWbCoA2D8='
WHERE
key_id = '100f9f82ba11030203d3b711bf805359c933fd30466249b439e5ac064333d67f'
AND (
token = 'RVwT6liaH5Cfy1v3Cr9hiy49ybpPznNhYLTWbCoA2D8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)