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