UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D10ev/dfB8KVD3u6QbbMCtX9E01m17Dij45XHTT9WWE='
WHERE
key_id = 'cef8e413e1e7913c30f07d473754bf72d17d6456927f2d56c14ca2369e8e6be3'
AND (
token = 'D10ev/dfB8KVD3u6QbbMCtX9E01m17Dij45XHTT9WWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)