UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BiURuogvZxs1UlwCN5kVomlobJ/G9yqyfPIA6n7AhPw='
WHERE
key_id = '0b8cb4332b93fcad9172a6e93fbe2332e13d9ec88cb39eebb86c66c4845c16fd'
AND (
token = 'BiURuogvZxs1UlwCN5kVomlobJ/G9yqyfPIA6n7AhPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)