UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R7p9k86ru0SWaIHJw9YuClogCuSJcVNJCwLhrWYWl+M='
WHERE
key_id = 'bb6e9e191690e7fcf93e69638fb62bdb4c45b8268a45c1245fe2ce1d6c37e0ab'
AND (
token = 'R7p9k86ru0SWaIHJw9YuClogCuSJcVNJCwLhrWYWl+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)