UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6g04StciyqX9Mj15V7QgRkucmsa66S/il/vMkS90ud8='
WHERE
key_id = '2a8d8dfe3c993b655c7d98d29284a74d3d62a8f244f2171b7c0ac04b02cf5501'
AND (
token = '6g04StciyqX9Mj15V7QgRkucmsa66S/il/vMkS90ud8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)