UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bxB0CZjzyv72PicPjMJ9fL3GgVu45WRRVYsxsigQJpo='
WHERE
key_id = 'a99dd081b50388800f81f5a48b7f218f119518337f43b10a3ed54adb28928439'
AND (
token = 'bxB0CZjzyv72PicPjMJ9fL3GgVu45WRRVYsxsigQJpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)