UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VssFgMly0tjX2to+9QaBtdc3KpkXDlRtnfADQdXl3wA='
WHERE
key_id = 'a4f2cddb215bb650359a8e28cd8206374722afa93f453787f7bc07ac8cc04659'
AND (
token = 'VssFgMly0tjX2to+9QaBtdc3KpkXDlRtnfADQdXl3wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)