UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QgH6bameL4845k+pQ8627JQduxjL9cc1nm+2Bff+GAI='
WHERE
key_id = '94d18e4d477ae61649e46f89e2e20a143523d1ea32ae75e70a573615a58c2e67'
AND (
token = 'QgH6bameL4845k+pQ8627JQduxjL9cc1nm+2Bff+GAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)