UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JnjHk7sMCmQJmkc42J8/u1Jk4gWlWjTVhmtaiwt0QAg='
WHERE
key_id = '1423f65da07192089349e93043f2a9be8273d990a9b320a35261c40f7c13245f'
AND (
token = 'JnjHk7sMCmQJmkc42J8/u1Jk4gWlWjTVhmtaiwt0QAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)