UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+MhHeiF4CkZX10ghUDv16Fo6tQ+IIYGml5D61iUgWQI='
WHERE
key_id = '73b935095182849f7a738187c9d2ae7137dbd027abbccca39e94c32df8ea10a0'
AND (
token = '+MhHeiF4CkZX10ghUDv16Fo6tQ+IIYGml5D61iUgWQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)