UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YQHd2HBz537Kd/1sJ6mpls6NygOZDJUmCkbqtghJPno='
WHERE
key_id = 'bc1c328807869b65d0d8c6aecd5d2ea21cd0b69d7de9b209a67b2dde70206efb'
AND (
token = 'YQHd2HBz537Kd/1sJ6mpls6NygOZDJUmCkbqtghJPno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)