UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uXkBrMqRloeFJ5wBT/RJipwcDFmSfYzyBROCdGlW62Y='
WHERE
key_id = 'a70d517b2426c1e8befbed9b0118aa96688a51b2123b4ba9d4b0d9f64ba9b934'
AND (
token = 'uXkBrMqRloeFJ5wBT/RJipwcDFmSfYzyBROCdGlW62Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)